/**
 * Software License, Version 1.0
 *
 * Copyright 2003 The Trustees of Indiana University.  All rights reserved.
 *
 *
 *Redistribution and use in source and binary forms, with or without
 *modification, are permitted provided that the following conditions are met:
 *
 *1) All redistributions of source code must retain the above copyright notice,
 * the list of authors in the original source code, this list of conditions and
 * the disclaimer listed in this license;
 *2) All redistributions in binary form must reproduce the above copyright
 * notice, this list of conditions and the disclaimer listed in this license in
 * the documentation and/or other materials provided with the distribution;
 *3) Any documentation included with all redistributions must include the
 * following acknowledgement:
 *
 *"This product includes software developed by the Community Grids Lab. For
 * further information contact the Community Grids Lab at
 * http://communitygrids.iu.edu/."
 *
 * Alternatively, this acknowledgement may appear in the software itself, and
 * wherever such third-party acknowledgments normally appear.
 *
 *4) The name Indiana University or Community Grids Lab or NaradaBrokering,
 * shall not be used to endorse or promote products derived from this software
 * without prior written permission from Indiana University.  For written
 * permission, please contact the Advanced Research and Technology Institute
 * ("ARTI") at 351 West 10th Street, Indianapolis, Indiana 46202.
 *5) Products derived from this software may not be called NaradaBrokering,
 * nor may Indiana University or Community Grids Lab or NaradaBrokering appear
 * in their name, without prior written permission of ARTI.
 *
 *
 * Indiana University provides no reassurances that the source code provided
 * does not infringe the patent or any other intellectual property rights of
 * any other entity.  Indiana University disclaims any liability to any
 * recipient for claims brought by any other entity based on infringement of
 * intellectual property rights or otherwise.
 *
 *LICENSEE UNDERSTANDS THAT SOFTWARE IS PROVIDED "AS IS" FOR WHICH NO
 *WARRANTIES AS TO CAPABILITIES OR ACCURACY ARE MADE. INDIANA UNIVERSITY GIVES
 *NO WARRANTIES AND MAKES NO REPRESENTATION THAT SOFTWARE IS FREE OF
 *INFRINGEMENT OF THIRD PARTY PATENT, COPYRIGHT, OR OTHER PROPRIETARY RIGHTS.
 *INDIANA UNIVERSITY MAKES NO WARRANTIES THAT SOFTWARE IS FREE FROM "BUGS",
 *"VIRUSES", "TROJAN HORSES", "TRAP DOORS", "WORMS", OR OTHER HARMFUL CODE.
 *LICENSEE ASSUMES THE ENTIRE RISK AS TO THE PERFORMANCE OF SOFTWARE AND/OR
 *ASSOCIATED MATERIALS, AND TO THE PERFORMANCE AND VALIDITY OF INFORMATION
 *GENERATED USING SOFTWARE.
 */
package cgl.narada.service.storage.db;

// The NbTables class include all the query for create/delete the tables needed
// for Storage Service.

// Author: Xi Rao
public class NbTables {

  public static final String CreateInventoryFull =
      "create table InventoryFull"+
      "("+
          "sequenceNumber bigint not null primary key,"+
          "previousSequenceNumber bigint,"+
          "eventID int,"+
          "event BLOB,"+
          "templateID int,"+
          "foreign key(templateID) references Template(templateID)"+
      ");";

  public static final String DropInventoryFull = "drop table InventoryFull;";

  public static final String CreateInventoryLight =
      "create table InventoryLight"+
      "("+
          "sequenceNumber bigint not null primary key,"+
          "previousSequenceNumber bigint,"+
          "templateID int,"+
          "foreign key(templateID) references Template(templateID)"+
      ");";
  public static final String DropInventoryLight = "drop table InventoryLight;";

  public static final String CreateProfile =
      "create table Profile" +
      "("+
          "profileID varchar(255) not null primary key,"+
          "profileType int,"+
          "subscription BLOB,"+
          "templateId int,"+
          "entityId int,"+
          "foreign key(entityId) references Entity,"+
          "foreign key(templateId) references Template"+
      ");";
  public static final String DropProfile = "drop table Profile;";

  public static final String CreateEntity =
      "create table Entity"+
      "("+
           "EntityId int not null primary key"+
      ");";
  public static final String DropEntity = "drop table Entity;";

  public static final String CreateTemplate =
      "create table Template(" +
          "templateID int not null primary key,"+
           "templateType int,"+
           "templateBytes BLOB"+
      ");";
  public static final String DropTemplate = "drop table Template;";

  public static final String CreateEntityTemplate =
      "create table EntityTemplate"+
      "("+
          "templateID int not null,"+
          "entityID int not null,"+
          "syncpoint bigint,"+
          "catenation int,"+
          "primary key(entityID, templateID),"+
          "foreign key(entityID) references Entity(entityID),"+
          "foreign key(templateID) references Template(templateID)"+
      ");";
  public static final String DropEntityTemplate = "drop table EntityTemplate;";

  public static final String CreateEntityInventory =
      "create table EntityInventory"+
          "("+
          "sequenceNumber bigint not null,"+
          "entityId int not null,"+
          "primary key(sequenceNumber, entityId),"+
          "foreign key(entityId) references Entity(entityId),"+
          "foreign key(inventoryID) references Inventory(sequenceNumber)"+
      ");";
  public static final String DropEntityInventory = "drop table EntityInventory;";

}